package com.cakebackoffice.database;


public class UnitarySaleTable extends DatabaseTable {
    public static final String TABLESNAME = "UnitarySaleTable";
    public static final String ID = "_id";
    public static final String REMOTE_ID = "remoteId";
    public static final String PRICE = "price";
    public static final String VAT = "vat";
    public static final String PRODUCTID = "productId";
    public static final String PRODUCTTYPEID = "productTypeId";
    public static final String MENUID = "menuId";
    public static final String MENUTYPEID = "menuTypeId";

    public static final String[] ALLFIELDS = new String[]{
            ID,
            REMOTE_ID,
            PRICE,
            VAT,
            PRODUCTID,
            PRODUCTTYPEID,
            MENUID,
            MENUTYPEID

    };

    public static final String CREATE = "CREATE TABLE " + TABLESNAME
            + " ( "
            + ID + " INTEGER PRIMARY KEY AUTOINCREMENT , "
            + REMOTE_ID + " INTEGER ,"
            + PRODUCTID + " INTEGER ,"
            + PRODUCTTYPEID + " INTEGER ,"
            + MENUID + " INTEGER ,"
            + MENUTYPEID + " INTEGER ,"
            + PRICE + " REAL , "
            + VAT + " REAL ); ";

    private static DatabaseTable ourInstance = new UnitarySaleTable();


    @Override
    public String getTableName() {
        return TABLESNAME;
    }

    @Override
    public String[] getAllFields() {
        return ALLFIELDS;
    }

    @Override
    public String getCreate() {
        return CREATE;
    }

    public static DatabaseTable getInstance() {
        return ourInstance;
    }

    private UnitarySaleTable() {
    }
}
